home *** CD-ROM | disk | FTP | other *** search
/ Clickx 75 / Clickx 75.iso / software / expressionweb / expressionwebv3 / ExpressionWeb_en.exe / Setup / WeConen.cab / xweb.vtidb.wiz.SUBMITX.HTX.en < prev    next >
Encoding:
Text File  |  2009-06-09  |  3.5 KB  |  93 lines
  1.  
  2.  
  3. <%BeginASP%>@ Page inherits="Microsoft.Office.FrontPage.DBInterface.DBInterfacePage" Src="<%IncPath%>_fpclass/fpdbnet.cs" Language="C#" debug = true<%EndASP%>
  4. <%BeginASP%>@ Register TagPrefix="FPDB" TagName="DBRegion" Src="<%IncPath%>_fpClass/dbregion.ascx"<%EndASP%>
  5. <%BeginASP%>@ Import NameSpace="System.Data"<%EndASP%>
  6. <HTML>
  7.     <HEAD>
  8.         <title>
  9.             <%SubmitPageTitle%>
  10.         </title>
  11.         <META http-equiv="Content-Type" content="text/html; charset=windows-1252">    
  12.     </HEAD>
  13.     <BODY>
  14.         <script Language="C#" runat="server">
  15.         public void Page_Load()
  16.         {
  17.             FieldNames="<%FieldNames%>";
  18.             FieldFriendlyNames="<%FriendlyNames%>";
  19.             FieldTypes="<%FieldTypes%>";
  20.             FieldDefaults="<%FieldDefaults%>";
  21.  
  22.             ResetErrorMessages();
  23.  
  24.             UseControls();
  25.             if( !IsPostBack )
  26.                 FillControlsWithDefaults( InputFieldsPanel );
  27.         }
  28.     
  29.         protected void ClickSaveButton(Object sender, EventArgs e)
  30.         {
  31.             DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
  32.             DataRow newDataRow = curDataTable.NewRow();
  33.         
  34.             try
  35.             {
  36.                 newDataRow.BeginEdit();
  37.                 if( FillRowWithControls( newDataRow, InputFieldsPanel, true ) )
  38.                 {
  39.                     newDataRow.EndEdit();
  40.                     curDataTable.Rows.Add( newDataRow );
  41.                     Connection.SaveChangesToDatabase();
  42.                     Session["DataRowAdded"] = "true";
  43.                     Response.Redirect("<%FormSubmitRedirect%>");
  44.                 }
  45.                 else
  46.                 {
  47.                     newDataRow.CancelEdit();
  48.                     String L_ErrPrefix_Err = "'"; 
  49.                     String L_ErrSuffix_Err = "' must be unique" ; 
  50.                     ErrorMessage( L_ErrPrefix_Err + Connection.TableKey + L_ErrSuffix_Err );
  51.                 }
  52.             }
  53.             catch( ApplicationException ex )
  54.             {
  55.                 ErrorMessage( ex.Message );
  56.             }
  57.         }
  58.     
  59.         protected void ClickButtonReset(Object sender, EventArgs e)
  60.         {
  61.             FillControlsWithDefaults( InputFieldsPanel );
  62.         }
  63.         </script>
  64.         <form runat="server">
  65.             <table width="100%" align="left">
  66.                 <tr>
  67.                     <td width="50%"><b><font color="#000080" size="+3"> 
  68.                                 
  69.                                 Submission Form</font></b>
  70.                     </td>
  71.                     <td align="right" valign="center">
  72.                         <%SubmissionNavTable%>
  73.                     </td>
  74.                 </tr>
  75.             </table>
  76.             <p>
  77.                 <br clear="all">
  78.                 <hr>
  79.             <P></P>
  80.             <div ID="InputFieldsPanel" runat="server">
  81.                 <table>
  82.                     <%InputFields%>
  83.                 </table>
  84.             </div>
  85.             <asp:Button ID="ButtonSave" OnClick="ClickSaveButton" Text="Submit" runat="server" />
  86.             <asp:Button ID="ButtonReset" OnClick="ClickButtonReset" Text="Reset" runat="server" />
  87.             <asp:label id="PageErrorTextLabel" Text="[Place holder for page error              messages]" runat="server" />
  88.             <FPDB:DBRegion ID="DBRegion" DBName="<%DBName%>" TableName="<%TableName%>" 
  89.             TableKey="<%TableKey%>" RootPath="<%IncPath%>" NoResults="noResultsLabel" runat="server" />
  90.         </form>
  91.     </BODY>
  92. </HTML>
  93.